IF OBJECT_ID(N'dbo.tblHPda', N'U') IS NULL
BEGIN

    CREATE TABLE [dbo].[tblHpda]
    (
        [AutoID] [NUMERIC](18, 0) IDENTITY(1, 1) NOT NULL PRIMARY KEY,
        [User_Tarikh] [SMALLDATETIME] NULL DEFAULT GETDATE(),
        [Kind_Flag] [CHAR](1) NULL,
        [totPrice] [MONEY] NULL DEFAULT ((0)),
        [ComputerName] [VARCHAR](35) NULL,
        [KindSave] [CHAR](1) NULL,
        [UserId] [INT] NULL,
        [OTCPrice] [MONEY] NULL,
        [A_Code] [VARCHAR](5) NULL,
        [Details] [NVARCHAR](MAX) NULL
        
    ) ON [PRIMARY];


END;

---------------------------------------------------
ELSE
BEGIN

    IF NOT EXISTS
    (
        SELECT 1
        FROM sys.columns
        WHERE name = N'AutoId'
              AND object_id = OBJECT_ID(N'dbo.tblHpda')
    )
    BEGIN
        ALTER TABLE dbo.tblHpda ADD [AutoId] NUMERIC(18, 0);
    END;
    --------------
    IF NOT EXISTS
    (
        SELECT 1
        FROM sys.columns
        WHERE name = N'User_Tarikh'
              AND object_id = OBJECT_ID(N'dbo.tblHpda')
    )
    BEGIN
        ALTER TABLE dbo.tblHpda ADD [User_Tarikh] SMALLDATETIME;
    END;
    ------------------------

    IF NOT EXISTS
    (
        SELECT 1
        FROM sys.columns
        WHERE name = N'Kind_Flag'
              AND object_id = OBJECT_ID(N'dbo.tblHpda')
    )
    BEGIN
        ALTER TABLE dbo.tblHpda ADD [Kind_Flag] CHAR(1);
    END;

    ------------------------
    IF NOT EXISTS
    (
        SELECT 1
        FROM sys.columns
        WHERE name = N'totPrice'
              AND object_id = OBJECT_ID(N'dbo.tblHpda')
    )
    BEGIN
        ALTER TABLE dbo.tblHpda ADD [totPrice] MONEY;
    END;


    -----------------
    IF NOT EXISTS
    (
        SELECT 1
        FROM sys.columns
        WHERE name = N'ComputerName'
              AND object_id = OBJECT_ID(N'dbo.tblHpda')
    )
    BEGIN
        ALTER TABLE dbo.tblHpda ADD [ComputerName] VARCHAR(35);
    END;

    --------------------
    IF NOT EXISTS
    (
        SELECT 1
        FROM sys.columns
        WHERE name = N'KindSave'
              AND object_id = OBJECT_ID(N'dbo.tblHpda')
    )
    BEGIN
        ALTER TABLE dbo.tblHpda ADD [KindSave] CHAR(1);
    END;
    ---------------

    IF NOT EXISTS
    (
        SELECT 1
        FROM sys.columns
        WHERE name = N'UserId'
              AND object_id = OBJECT_ID(N'dbo.tblHpda')
    )
    BEGIN
        ALTER TABLE dbo.tblHpda ADD [UserId] INT;
    END;
    -----------------------
    IF NOT EXISTS
    (
        SELECT 1
        FROM sys.columns
        WHERE name = N'OTCPrice'
              AND object_id = OBJECT_ID(N'dbo.tblHpda')
    )
    BEGIN
        ALTER TABLE dbo.tblHpda ADD [OTCPrice] MONEY;
    END;
    --------------
    IF NOT EXISTS
    (
        SELECT 1
        FROM sys.columns
        WHERE name = N'A_Code'
              AND object_id = OBJECT_ID(N'dbo.tblHpda')
    )
    BEGIN
        ALTER TABLE dbo.tblHpda ADD [A_Code] VARCHAR(5);
    END;
-----------------------
	 IF NOT EXISTS
    (
        SELECT 1
        FROM sys.columns
        WHERE name = N'Details'
              AND object_id = OBJECT_ID(N'dbo.tblHpda')
    )
    BEGIN
        ALTER TABLE dbo.tblHpda ADD [Details] NVARCHAR(MAX);
    END;


END;